<test>
  <sql>WITH EmployeeHierarchy AS
(				
   -- Base case
   SELECT	e.EmployeeID,
   			0
   FROM		Employees e
   WHERE	ReportsTo IS NULL

   UNION ALL

   -- Recursive step
   SELECT	e.EmployeeID,
   			eh.Level + 1
   FROM		Employees e
				INNER JOIN EmployeeHierarchy eh ON e.ReportsTo = eh.EmployeeID
)
SELECT	*
FROM	EmployeeHierarchy eh
ORDER	BY Path</sql>
  <expectedErrors>
    <expectedError id="NoColumnAliasSpecified" text="No column name was specified for column 2 of 'EmployeeHierarchy'." />
  </expectedErrors>
</test>